<html>
    <body>
        <form method="POST" action="Recherche.php">
            <fieldset class="input">
                <p id="inputbox">
                    <label><font size="2">Titre du Film</font></label>
                    <input type="Text" name="Titre" STYLE='font-family:Garamond; font-size:medium;
                           font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted'>
                </p>
                <br \>
                    <p id="inputbox">
                    <label><font size="2">Type de support</font></label>
                    <Select name='Support' STYLE='font-family:Garamond; font-size:medium;
                            font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted'>Choix
                        <Option value='DVD'>DVD
                        <Option value='VHS'>VHS
                        <Option value='Indifferent'>Indifferent
                    </Select>
                </p>
                <br \>
                    <p id="inputbox">
                    <label><font size="2">Disponibilite du Film</font></label>
                    <Select name='Statut' STYLE='font-family:Garamond; font-size:medium;
                            font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted'>Choix
                        <Option value='disponible'>Disponible
                        <Option value='Indifferent'>Indifferent
                    </Select>
                </p>
                <br \>
                    <p id="inputbox">
                    <?php
                    require ("connect.php");
                    $req = "SELECT `Genre`"
                    ."FROM `films`"
                    ."GROUP BY `Genre`";
                    $resul = DB_execSQL($req,$serv);
                    echo "<label><font size='2'>Genre du Film </font></label>"
                    ."<Select name='Genre' STYLE='font-family:Garamond; font-size:medium;
                    font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted'>Choix"
                    ."<Option value='Indifferent'>";

                    while ($genre = mysql_fetch_object($resul)){
                        echo "<Option value='".$genre->Genre."'>".$genre->Genre."\n";
                    }
                    echo "</Select>";
                    ?>
                </p>
                <br \>
                    <p id="inputbox">
                    <?php
                    require ("connect.php");
                    $req = "SELECT `Realisateur`"
                    ."FROM `films`"
                    ."GROUP BY `Realisateur`";
                    $resul = DB_execSQL($req,$serv);

                    echo "<label><font size='2'>Nom du realisateur </font></label>"
                    ."<Select name='Realisateur' STYLE='font-family:Garamond; font-size:medium;
                    font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted'>"
                    ."<Option value='Indifferent'>";
                    while ($reali = mysql_fetch_object($resul)){
                        echo "<Option value='".$reali->Realisateur."'>".$reali->Realisateur."\n";
                    }
                    echo "</Select>";
                    ?>
                </p>
                <br \>
                    <p id="inputbox">
                    <?php
                    require ("connect.php");
                    $req = "SELECT `Acteur`"
                    ."FROM `acteurs`"
                    ."GROUP BY `Acteur`";
                    $resul = DB_execSQL($req,$serv);

                    echo "<label><font size='2'>Nom d'un acteur </font></label>"
                    ."<Select name='Acteur' STYLE='font-family:Garamond; font-size:medium;
                    font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted'>"
                    ."<Option value='Indifferent'>";

                    while ($acteur = mysql_fetch_object($resul)){
                        echo "<Option value='".$acteur->Acteur."'>".$acteur->Acteur."\n";
                    }
                    echo "</Select>";

                    ?></p>
                <br \>
                    <p><input type="submit" name="Submit" class="button" value="Valider" STYLE="font-family:Garamond; font-size:medium;
                          font-style:normal; background:#444444 none; color:#FFF; border: 1px dotted"></p>
            </fieldset>
        </form>
    </body>
</html>